MUSA 508 Final Project
This project presents a comprehensive statistical analysis of urban development in Philadelphia, focusing on the intricate balance between growth, affordability, and gentrification. Central to this study is the development of a random forest model, which has demonstrated remarkable effectiveness in predicting future development patterns with a low mean absolute error. By accurately forecasting where growth is likely to occur, this model serves as a critical tool for urban planners and policymakers. It can be strategically leveraged to promote proactive upzoning of high-priority parcels, aligning current zoning more closely with anticipated development. This approach is particularly aimed at fostering affordable housing in Philadelphia, addressing one of the city’s most pressing challenges. Through this blend of data-driven insights and targeted policy recommendations, the project seeks to guide Philadelphia towards a more equitable and sustainable urban future.
required_packages <- c("tidyverse", "sf", "acs", "tidycensus", "sfdep", "kableExtra", "conflicted",
"gganimate", "tmap", "gifski", "transformr", "ggpubr", "randomForest", "janitor",
'igraph', "plotly", "ggcorrplot", "Kendall")
suppressWarnings(
install_and_load_packages(required_packages)
)
source("utils/viz_utils.R")Philadelphia, the sixth-largest city in the United States, presents a unique case study in urban development. Despite its ranking as the 42nd in terms of cost of living, the city’s approach to housing supply and affordability stands out. In the complex landscape of urban growth, Philadelphia treads a precarious line, balancing the benefits of new construction with the challenges of affordability and gentrification. This statistical analysis aims to delve into these dynamics, examining how the city’s growth, often perceived as a political rather than a strategic or ‘smart’ process, impacts its residents and neighborhoods.
The citywide impact of development in Philadelphia suggests a positive trend towards increased affordability and choice for its inhabitants. However, this macro view masks the localized burdens of development, where the cost and impact of new construction can be disproportionately felt. The central question then arises: How can Philadelphia grow equitably? The answer may lie in the concept of ‘smart growth’, a strategic approach to urban planning. But in reality, growth in Philadelphia is more influenced by political forces than by comprehensive, well-thought-out plans. Comprehensive plans, ideally set on ten-year timelines, often become mere suggestions, subject to the whims of city council members rather than serving as steadfast guides for development.
The statistical analysis will further explore the critical issue of zoning mismatch, a barrier to ensuring dense and equitable growth in Philadelphia. The current system, where permitting is largely controlled by individual council members (‘council-member-time’), often leads to a situation where exceptions to zoning rules unfairly become the norm. This analysis aims to provide dynamic data and insights to empower zoning advocates, offering them the tools to effectively counter these forces. By highlighting the need for intervention and the reduction of zoning mismatches, the study seeks to contribute to a broader understanding of how Philadelphia can navigate its growth challenges and opportunities, moving towards a more equitable and sustainable urban future.
Predict development pressure: how do we define “a lot of development”?
Define affordability burden: how do we define “affordability burden”? – % change year over year in population that is experience rate burden (will probably see extreme tipping points), growing population, % change in area incomes
Identify problem zoning
Calculate number of connected parcels
Predict development pressure at the block level
Identify not burdened areas
Identify problem zoning
Calcualte number of connected parcels
Advocate for upzoning in parcels where there is local development pressure, no affordability burden, problem zoning, and high number of connected parcels
urls <- c(
roads = 'https://opendata.arcgis.com/datasets/261eeb49dfd44ccb8a4b6a0af830fdc8_0.geojson', # for broad and market
council_dists = "https://opendata.arcgis.com/datasets/9298c2f3fa3241fbb176ff1e84d33360_0.geojson",
building_permits = building_permits_path,
permits_bg = final_dataset_path,
zoning = "https://opendata.arcgis.com/datasets/0bdb0b5f13774c03abf8dc2f1aa01693_0.geojson",
opa = "data/opa_properties.geojson"
)
suppressMessages({
invisible(
imap(urls, ~ assign(.y, phl_spat_read(.x), envir = .GlobalEnv))
)
})
broad_and_market <- roads %>% filter(ST_NAME %in% c('BROAD',"MARKET") | SEG_ID %in% c(440370, 421347,421338,421337,422413,423051,440403,440402,440391,440380))
council_dists <- council_dists %>%
select(DISTRICT)
building_permits <- building_permits %>%
filter(permittype %in% c("RESIDENTIAL BUILDING", "BP_ADDITION", "BP_NEWCNST"))tm_shape(permits_bg %>% filter(year == 2023)) +
tm_polygons(col = palette[4], alpha = 0.5, colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "darkgrey") +
tm_layout(frame = FALSE, title = "Philadelphia Block Groups") 
# tm_out <- tm_shape(acs22) +
# tm_polygons(col = "Ext_Rent_Burden", border.alpha = 0, palette = mono_5_orange, style = "fisher", colorNA = "lightgrey", title = "Extreme Rent Burden") +
# tm_shape(broad_and_market) +
# tm_lines(col = "darkgrey") +
# tm_layout(frame = FALSE, title = "Extreme Rent Burden\nPhiladelphia, 2022")
#
# tmap_save(tm_out, "assets/extreme_rent_burden_2022.jpg", dpi = 500)
tm <- tm_shape(permits_bg %>% filter(!year %in% c(2012, 2023, 2024))) +
tm_polygons(col = "permits_count", border.alpha = 0, palette = mono_5_green, style = "fisher", colorNA = "lightgrey") +
tm_facets(along = "year") +
tm_shape(broad_and_market) +
tm_lines(col = "darkgrey") +
tm_layout(frame = FALSE)
suppressMessages(
tmap_animation(tm, "assets/permits_animation.gif", delay = 50)
)
ggplot(building_permits %>% filter(!year %in% c(2024)), aes(x = as.factor(year))) +
geom_bar(fill = palette[1], color = NA, alpha = 0.7) +
labs(title = "Permits per Year") +
theme_minimal()
ggplot(permits_bg %>% st_drop_geometry %>% filter(!year %in% c(2024)), aes(x = permits_count)) +
geom_histogram(fill = palette[1], color = NA, alpha = 0.7) +
labs(title = "Permits per Block Group per Year",
subtitle = "Log-Transformed") +
scale_x_log10() +
facet_wrap(~year) +
theme_minimal()
#
# tm_shape(permits_bg) +
# tm_polygons("spat_lag_permits", border.alpha = 0, palette = 'viridis', style = "fisher", colorNA = "lightgrey") +
# tm_facets(along = "year") +
# tm_shape(broad_and_market) +
# tm_lines(col = "lightgrey") +
# tm_layout(frame = FALSE)perms_x_dist <- st_join(building_permits, council_dists)
perms_x_dist_sum <- perms_x_dist %>%
st_drop_geometry() %>%
group_by(DISTRICT, year) %>%
summarize(permits_count = n())
perms_x_dist_mean = perms_x_dist_sum %>%
group_by(year) %>%
summarize(permits_count = mean(permits_count)) %>%
mutate(DISTRICT = "Average")
perms_x_dist_sum <- bind_rows(perms_x_dist_sum, perms_x_dist_mean) %>%
mutate(color = ifelse(DISTRICT != "Average", 0, 1))
ggplotly(
ggplot(perms_x_dist_sum %>% filter(year > 2013, year < 2024), aes(x = year, y = permits_count, color = as.character(color), group = interaction(DISTRICT, color))) +
geom_line(lwd = 0.7) +
labs(title = "Permits per Year by Council District",
y = "Total Permits") +
# facet_wrap(~DISTRICT) +
theme_minimal() +
theme(axis.title.x = element_blank(),
legend.position = "none") +
scale_color_manual(values = c(palette[5], palette[1]))
)corr_vars <- c("total_pop",
"med_inc",
"percent_nonwhite",
"percent_renters",
"rent_burden",
"ext_rent_burden")
corr_dat <- permits_bg %>% select(all_of(corr_vars)) %>% select(where(is.numeric)) %>% st_drop_geometry() %>% unique() %>% na.omit()
corr <- round(cor(corr_dat), 2)
p.mat <- cor_pmat(corr_dat)
ggcorrplot(corr, p.mat = p.mat, hc.order = TRUE,
type = "full", insig = "blank", lab = TRUE, colors = c(palette[2], "white", palette[3]))
Local Moran’s i for 2023
lisa <- permits_bg %>%
filter(year == 2023) %>%
mutate(nb = st_contiguity(geometry),
wt = st_weights(nb),
permits_lag = st_lag(permits_count, nb, wt),
moran = local_moran(permits_count, nb, wt)) %>%
tidyr::unnest(moran) %>%
mutate(pysal = ifelse(p_folded_sim <= 0.1, as.character(pysal), NA),
hotspot = case_when(
pysal == "High-High" ~ "Signficant",
TRUE ~ "Not Signficant"
))
#
# palette <- c("High-High" = "#B20016",
# "Low-Low" = "#1C4769",
# "Low-High" = "#24975E",
# "High-Low" = "#EACA97")
morans_i <- tm_shape(lisa) +
tm_polygons(col = "ii", border.alpha = 0, style = "jenks", palette = 'viridis')
p_value <- tm_shape(lisa) +
tm_polygons(col = "p_ii", border.alpha = 0, style = "jenks", palette = '-viridis')
sig_hotspots <- tm_shape(lisa) +
tm_polygons(col = "hotspot", border.alpha = 0, style = "cat", palette = 'viridis', textNA = "Not a Hotspot")
tmap_arrange(morans_i, p_value, sig_hotspots, ncol = 3)
Emergeging hotspots
# stc <- as_spacetime(permits_bg,
# .loc_col = "geoid10",
# .time_col = "year")
#
# # conduct EHSA
# ehsa <- emerging_hotspot_analysis(
# x = stc,
# .var = "permits_count",
# k = 1,
# nsim = 5
# )
#
# count(ehsa, classification)permits_bg_long <- permits_bg %>%
filter(!year %in% c(2024)) %>%
st_drop_geometry() %>%
pivot_longer(
cols = c(starts_with("lag"), dist_to_2022),
names_to = "Variable",
values_to = "Value"
)
ggscatter(permits_bg_long, x = "permits_count", y = "Value", facet.by = "Variable",
add = "reg.line",
add.params = list(color = palette[3], fill = palette[5]),
conf.int = TRUE
) + stat_cor(method = "pearson", p.accuracy = 0.001, r.accuracy = 0.01)
Make sure to note that we train, test, and then validate. So these first models are based on 2022 data, and then we run another on 2023 (and then predict 2024 at the end).
To begin, we run a simple regression incorporating three engineered groups of features: space lag, time lag, and distance to 2022. We include this last variable because of a Philadelphia tax abatement policy that led to a significant increase in residential development in the years immediately before 2022. We will use this as a baseline model to compare to our more complex models.
(We considered a Poisson model but found that it struggled with outliers.)
permits_train <- filter(permits_bg %>% select(-c(mapname, geoid10)), year < 2022)
permits_test <- filter(permits_bg %>% select(-c(mapname, geoid10)), year == 2022)
permits_validate <- filter(permits_bg %>% select(-c(mapname, geoid10)), year == 2023)
permits_predict <- filter(permits_bg %>% select(-c(mapname, geoid10)), year == 2024)
reg <- lm(permits_count ~ ., data = st_drop_geometry(permits_train))
predictions <- predict(reg, permits_test)
predictions <- cbind(permits_test, predictions)
predictions <- predictions %>%
mutate(abs_error = abs(permits_count - predictions),
pct_error = abs_error / permits_count)
ggplot(predictions, aes(x = permits_count, y = predictions)) +
geom_point() +
labs(title = "Predicted vs. Actual Permits",
subtitle = "2022") +
geom_smooth(method = "lm", se = FALSE)
mae <- paste0("MAE: ", round(mean(predictions$abs_error, na.rm = TRUE), 2))
tm_shape(predictions) +
tm_polygons(col = "abs_error", border.alpha = 0, palette = 'viridis', style = "fisher", colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE) 
We find that our OLS model has an MAE of only MAE: 2.66–not bad for such a simple model! Still, it struggles most in the areas where we most need it to succeed, so we will try to introduce better variables and apply a more complex model to improve our predictions.
rf <- randomForest(permits_count ~ .,
data = st_drop_geometry(permits_train),
importance = TRUE,
na.action = na.omit)
rf_predictions <- predict(rf, permits_test)
rf_predictions <- cbind(permits_test, rf_predictions)
rf_predictions <- rf_predictions %>%
mutate(abs_error = abs(permits_count - rf_predictions),
pct_error = abs_error / (permits_count + 0.0001))
tm_shape(rf_predictions) +
tm_polygons(col = "rf_predictions", border.alpha = 0, palette = mono_5_green, style = "fisher", colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE) 
ggplot(rf_predictions, aes(x = permits_count, y = rf_predictions)) +
geom_point() +
labs(title = "Predicted vs. Actual Permits",
subtitle = "2022") +
geom_smooth(method = "lm", se = FALSE)
rf_mae <- paste0("MAE: ", round(mean(rf_predictions$abs_error, na.rm = TRUE), 2))
tm_shape(rf_predictions) +
tm_polygons(col = "abs_error", border.alpha = 0, palette = mono_5_orange, style = "fisher", colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE) 
Predominately, our model overpredicts, which is better than underpredicting, as it facilitates new development.
nbins <- as.integer(sqrt(nrow(rf_predictions)))
vline <- mean(rf_predictions$abs_error, na.rm = TRUE)
ggplot(rf_predictions, aes(x = abs_error)) +
geom_histogram(bins = nbins) +
geom_vline(aes(xintercept = vline))
hmm <- permits_bg %>%
st_drop_geometry() %>%
group_by(year) %>%
summarize_all(.funs = list(~sum(is.na(.)))) # Check NA for all columnsrf_predictions <- rf_predictions %>%
mutate(race_comp = case_when(
percent_nonwhite >= .50 ~ "Majority Non-White",
TRUE ~ "Majority White"
))
ggplot(rf_predictions, aes(y = abs_error, color = race_comp)) +
geom_boxplot(fill = NA)
We find that error is not related to affordability and actually trends downward with percent nonwhite. (This is probably because there is less total development happening there in majority-minority neighborhoods to begin with, so the magnitude of error is less, even though proportionally it might be more.) Error increases slightly with total pop. This makes sense–more people –> more development.
ggplot(rf_predictions, aes(y = abs_error, x = rent_burden)) + # or whatever the variable is
geom_point() +
geom_smooth(method = "lm", se= FALSE) +
theme_minimal()
ggplot(rf_predictions, aes(y = abs_error, x = percent_nonwhite)) + # or whatever the variable is
geom_point() +
geom_smooth(method = "lm", se= FALSE) +
theme_minimal()
ggplot(rf_predictions, aes(y = abs_error, x = total_pop)) + # or whatever the variable is
geom_point() +
geom_smooth(method = "lm", se= FALSE) +
theme_minimal()
ggplot(rf_predictions, aes(y = abs_error, x = med_inc)) + # or whatever the variable is
geom_point() +
geom_smooth(method = "lm", se= FALSE) +
theme_minimal()
How does this generalize across council districts? Don’t forget to refactor
suppressMessages(
ggplot(rf_predictions, aes(x = reorder(district, abs_error, FUN = mean), y = abs_error)) +
geom_boxplot(fill = NA) +
labs(title = "MAE by Council District",
y = "Mean Absolute Error",
x = "Council District") +
theme_minimal() +
theme()
)
We can identify conflict between projected development and current zoning.
Look at zoning that is industrial or residential single family in areas that our model suggests are high development risk for 2023:
filtered_zoning <- zoning %>%
filter(str_detect(CODE, "RS") | str_detect(CODE, "I"),
CODE != "I2",
!str_detect(CODE, "SP"))
tm_shape(filtered_zoning) +
tm_polygons(col = "CODE", border.alpha = 0, colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE)
We can extract development predictions at the block level to these parcels and then visualize them by highest need.
filtered_zoning <- st_join(
filtered_zoning,
rf_predictions %>% select(rf_predictions)
)
tm_shape(filtered_zoning) +
tm_polygons(col = "rf_predictions", border.alpha = 0, colorNA = "lightgrey", palette = mono_5_orange, style = "fisher") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE)
tmap_mode('view')
filtered_zoning %>%
filter(rf_predictions > 10) %>%
tm_shape() +
tm_polygons(col = "CODE", border.alpha = 0, colorNA = "lightgrey",
popup.vars = c('rf_predictions', 'CODE')) +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE)Furthermore, we can identify properties with high potential for assemblage, which suggests the ability to accomodate high-density, multi-unit housing.
nbs <- filtered_zoning %>%
mutate(nb = st_contiguity(geometry))
# Create edge list while handling cases with no neighbors
edge_list <- tibble::tibble(id = 1:length(nbs$nb), nbs = nbs$nb) %>%
tidyr::unnest(nbs) %>%
filter(nbs != 0)
# Create a graph with a node for each row in filtered_zoning
g <- make_empty_graph(n = nrow(filtered_zoning))
V(g)$name <- as.character(1:nrow(filtered_zoning))
# Add edges if they exist
if (nrow(edge_list) > 0) {
edges <- as.matrix(edge_list)
g <- add_edges(g, c(t(edges)))
}
# Calculate the number of contiguous neighbors, handling nodes without neighbors
n_contiguous <- sapply(V(g)$name, function(node) {
if (node %in% edges) {
length(neighborhood(g, order = 1, nodes = as.numeric(node))[[1]])
} else {
1 # Nodes without neighbors count as 1 (themselves)
}
})
filtered_zoning <- filtered_zoning %>%
mutate(n_contig = n_contiguous)
filtered_zoning %>%
st_drop_geometry() %>%
select(rf_predictions,
n_contig,
OBJECTID,
CODE) %>%
filter(rf_predictions > 10,
n_contig > 2) %>%
arrange(desc(rf_predictions)) %>%
kablerize(caption = "Poorly-Zoned Properties with High Development Risk")| rf_predictions | n_contig | OBJECTID | CODE | |
|---|---|---|---|---|
| 7517 | 44.30107 | 3 | 16717 | RSA5 |
| 4957 | 40.74193 | 3 | 10410 | ICMX |
| 4958 | 40.74193 | 3 | 10411 | RSA5 |
| 4959 | 40.74193 | 3 | 10412 | ICMX |
| 5245 | 40.74193 | 3 | 11160 | RSA5 |
| 1768 | 35.47850 | 3 | 3128 | IRMX |
| 3640 | 35.47850 | 3 | 6901 | ICMX |
| 4460 | 30.76787 | 3 | 9093 | RSA5 |
| 3934 | 27.38013 | 3 | 7646 | ICMX |
| 12326 | 27.38013 | 4 | 25776 | RSA5 |
| 868 | 22.99130 | 3 | 1615 | ICMX |
| 1548 | 22.99130 | 3 | 2736 | IRMX |
| 1587 | 22.99130 | 3 | 2804 | IRMX |
| 3420 | 22.99130 | 3 | 6405 | RSA5 |
| 4667 | 22.99130 | 3 | 9661 | RSA5 |
| 9169 | 22.99130 | 4 | 20073 | ICMX |
| 13578 | 22.61317 | 3 | 27869 | IRMX |
| 5088 | 20.42487 | 3 | 10759 | IRMX |
| 3957 | 19.28720 | 3 | 7704 | IRMX |
| 7833 | 17.59670 | 3 | 17408 | RSA5 |
| 7726 | 17.17243 | 3 | 17168 | ICMX |
| 6645 | 15.82543 | 3 | 14648 | ICMX |
| 7280 | 15.82543 | 3 | 16179 | RSA5 |
| 9912 | 15.82543 | 3 | 21527 | ICMX |
| 2138 | 13.89840 | 4 | 3744 | IRMX |
| 5964 | 13.76803 | 3 | 12931 | ICMX |
| 6396 | 13.76803 | 3 | 13980 | RSA3 |
| 6540 | 13.76803 | 3 | 14372 | RSA5 |
| 6550 | 13.76803 | 3 | 14401 | RSA5 |
| 6691 | 12.95807 | 3 | 14747 | ICMX |
| 4512 | 12.27660 | 5 | 9243 | IRMX |
| 6014 | 12.27660 | 6 | 13057 | ICMX |
| 6200 | 12.04267 | 4 | 13532 | ICMX |
| 4146 | 11.90437 | 3 | 8265 | IRMX |
| 5108 | 11.90437 | 4 | 10795 | IRMX |
| 5776 | 11.81497 | 3 | 12473 | RSA5 |
| 8252 | 11.81497 | 3 | 18254 | RSA3 |
| 12840 | 11.81497 | 3 | 26627 | RSA5 |
| 4318 | 11.02767 | 3 | 8705 | RSD3 |
| 13270 | 11.02767 | 3 | 27311 | RSD1 |
| 13750.1 | 11.02767 | 3 | 28226 | RSA3 |
| 3007 | 10.68323 | 3 | 5506 | RSA5 |
| 4558 | 10.68323 | 3 | 9370 | ICMX |
| 1536 | 10.66743 | 4 | 2715 | ICMX |
| 2422 | 10.66743 | 5 | 4284 | IRMX |
| 2941 | 10.66743 | 4 | 5351 | RSA5 |
| 10490.1 | 10.66743 | 3 | 22527 | I3 |
| 10810 | 10.66743 | 5 | 23106 | ICMX |
| 11135.1 | 10.66743 | 8 | 23678 | I3 |
| 2635.1 | 10.35287 | 4 | 4707 | RSD3 |
| 8835.1 | 10.35287 | 5 | 19390 | RSA3 |
| 11306 | 10.35287 | 3 | 24004 | RSA3 |
| 11333 | 10.35287 | 3 | 24065 | RSA5 |
| 11519 | 10.35287 | 4 | 24444 | RSD3 |
| 13606 | 10.35287 | 3 | 27915 | RSA3 |
| 13607 | 10.35287 | 5 | 27916 | RSA5 |
| 13611 | 10.35287 | 4 | 27921 | RSD3 |
| 13340 | 10.34050 | 3 | 27419 | RSD3 |
| 14033 | 10.34050 | 3 | 28807 | RSD3 |
| 14034 | 10.34050 | 3 | 28808 | RSD1 |
| 1380 | 10.17810 | 3 | 2457 | RSD3 |
| 13750 | 10.17810 | 3 | 28226 | RSA3 |
| 5706 | 10.05437 | 3 | 12329 | ICMX |
tmap_mode('view')
filtered_zoning %>%
select(rf_predictions,
n_contig,
OBJECTID,
CODE) %>%
filter(rf_predictions > 10,
n_contig > 2) %>%
tm_shape() +
tm_polygons(col = "rf_predictions", border.alpha = 0, colorNA = "lightgrey", palette = "viridis", style = "fisher",
popup.vars = c('rf_predictions', 'n_contig', 'CODE'), alpha = 0.5) +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE)Just for shits and giggles, throw in 2024 predictions. (Can use data from 2023.)
rf_predictions_2024 <- predict(rf, permits_predict)
rf_predictions_2024 <- cbind(permits_predict, rf_predictions_2024)
tm_shape(rf_predictions_2024) +
tm_polygons(col = "rf_predictions_2024", border.alpha = 0, palette = mono_5_green, style = "fisher", colorNA = "lightgrey") +
tm_shape(broad_and_market) +
tm_lines(col = "lightgrey") +
tm_layout(frame = FALSE)